Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 1419263 |
| Missing cells | 1609486 |
| Missing cells (%) | 3.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 314.0 MiB |
| Average record size in memory | 232.0 B |
Variable types
| Numeric | 3 |
|---|---|
| Categorical | 24 |
| Boolean | 2 |
Rndrng_Prvdr_Last_Org_Name has a high cardinality: 180859 distinct values | High cardinality |
Rndrng_Prvdr_First_Name has a high cardinality: 49837 distinct values | High cardinality |
Rndrng_Prvdr_Crdntls has a high cardinality: 9299 distinct values | High cardinality |
Rndrng_Prvdr_St1 has a high cardinality: 243256 distinct values | High cardinality |
Rndrng_Prvdr_St2 has a high cardinality: 41274 distinct values | High cardinality |
Rndrng_Prvdr_City has a high cardinality: 10579 distinct values | High cardinality |
Rndrng_Prvdr_State_Abrvtn has a high cardinality: 61 distinct values | High cardinality |
Rndrng_Prvdr_Zip5 has a high cardinality: 19042 distinct values | High cardinality |
Rndrng_Prvdr_Type has a high cardinality: 99 distinct values | High cardinality |
HCPCS_Cd has a high cardinality: 4604 distinct values | High cardinality |
HCPCS_Desc has a high cardinality: 4239 distinct values | High cardinality |
Tot_Benes has a high cardinality: 3691 distinct values | High cardinality |
Tot_Srvcs has a high cardinality: 10080 distinct values | High cardinality |
Tot_Bene_Day_Srvcs has a high cardinality: 5073 distinct values | High cardinality |
Avg_Sbmtd_Chrg has a high cardinality: 128266 distinct values | High cardinality |
Avg_Mdcr_Alowd_Amt has a high cardinality: 68010 distinct values | High cardinality |
Avg_Mdcr_Pymt_Amt has a high cardinality: 59738 distinct values | High cardinality |
Avg_Mdcr_Stdzd_Amt has a high cardinality: 53642 distinct values | High cardinality |
Rndrng_Prvdr_Ent_Cd is highly correlated with Rndrng_Prvdr_Type and 2 other fields | High correlation |
Rndrng_Prvdr_Type is highly correlated with Rndrng_Prvdr_Ent_Cd and 1 other fields | High correlation |
Rndrng_Prvdr_MI is highly correlated with Rndrng_Prvdr_Ent_Cd | High correlation |
Rndrng_Prvdr_Gndr is highly correlated with Rndrng_Prvdr_Ent_Cd | High correlation |
Place_Of_Srvc is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_Gndr is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_Ent_Cd is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_State_Abrvtn is highly correlated with Rndrng_Prvdr_State_FIPS and 3 other fields | High correlation |
Rndrng_Prvdr_State_FIPS is highly correlated with Rndrng_Prvdr_State_Abrvtn and 1 other fields | High correlation |
Rndrng_Prvdr_RUCA is highly correlated with Rndrng_Prvdr_State_Abrvtn and 2 other fields | High correlation |
Rndrng_Prvdr_RUCA_Desc is highly correlated with Rndrng_Prvdr_State_Abrvtn and 1 other fields | High correlation |
Rndrng_Prvdr_Cntry is highly correlated with Rndrng_Prvdr_State_Abrvtn | High correlation |
Rndrng_Prvdr_Type is highly correlated with Rndrng_Prvdr_Gndr and 2 other fields | High correlation |
Place_Of_Srvc is highly correlated with Rndrng_Prvdr_Type | High correlation |
Rndrng_Prvdr_First_Name has 61069 (4.3%) missing values | Missing |
Rndrng_Prvdr_MI has 438461 (30.9%) missing values | Missing |
Rndrng_Prvdr_Crdntls has 110474 (7.8%) missing values | Missing |
Rndrng_Prvdr_Gndr has 61069 (4.3%) missing values | Missing |
Rndrng_Prvdr_St2 has 935854 (65.9%) missing values | Missing |
Rndrng_Prvdr_RUCA is highly skewed (γ1 = 22.65286645) | Skewed |
Reproduction
| Analysis started | 2022-01-15 10:22:18.326433 |
|---|---|
| Analysis finished | 2022-01-15 10:24:57.378226 |
| Duration | 2 minutes and 39.05 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
Rndrng_NPI
Real number (ℝ≥0)
| Distinct | 629503 |
|---|---|
| Distinct (%) | 44.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1499135331 |
| Minimum | 1003000134 |
|---|---|
| Maximum | 1992999825 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.8 MiB |
Quantile statistics
| Minimum | 1003000134 |
|---|---|
| 5-th percentile | 1053303964 |
| Q1 | 1245657278 |
| median | 1497945216 |
| Q3 | 1740622699 |
| 95-th percentile | 1942687785 |
| Maximum | 1992999825 |
| Range | 989999691 |
| Interquartile range (IQR) | 494965421 |
Descriptive statistics
| Standard deviation | 287769373.3 |
|---|---|
| Coefficient of variation (CV) | 0.1919569017 |
| Kurtosis | -1.197802575 |
| Mean | 1499135331 |
| Median Absolute Deviation (MAD) | 242787854 |
| Skewness | -0.01354769181 |
| Sum | 2.127667307 × 1015 |
| Variance | 8.281121223 × 1016 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1366479099 | 90 | < 0.1% |
| 1538144910 | 89 | < 0.1% |
| 1134277494 | 89 | < 0.1% |
| 1891731626 | 87 | < 0.1% |
| 1063497451 | 86 | < 0.1% |
| 1932145778 | 84 | < 0.1% |
| 1205872041 | 80 | < 0.1% |
| 1538105366 | 79 | < 0.1% |
| 1790721538 | 78 | < 0.1% |
| 1881630614 | 77 | < 0.1% |
| Other values (629493) | 1418424 |
| Value | Count | Frequency (%) |
| 1003000134 | 2 | < 0.1% |
| 1003000142 | 1 | < 0.1% |
| 1003000522 | 1 | < 0.1% |
| 1003000530 | 2 | < 0.1% |
| 1003000597 | 9 | |
| 1003000639 | 1 | < 0.1% |
| 1003000738 | 1 | < 0.1% |
| 1003000829 | 1 | < 0.1% |
| 1003000936 | 4 | |
| 1003001041 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1992999825 | 3 | |
| 1992999775 | 1 | < 0.1% |
| 1992999551 | 2 | < 0.1% |
| 1992999437 | 1 | < 0.1% |
| 1992999270 | 1 | < 0.1% |
| 1992999122 | 5 | |
| 1992998736 | 1 | < 0.1% |
| 1992998710 | 1 | < 0.1% |
| 1992998702 | 1 | < 0.1% |
| 1992998645 | 2 | < 0.1% |
| Distinct | 180859 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| Patel | 8615 |
|---|---|
| Smith | 7432 |
| Lee | 5285 |
| Johnson | 5247 |
| Walgreen Co | 5082 |
| Other values (180854) |
Length
| Max length | 70 |
|---|---|
| Median length | 6 |
| Mean length | 7.346388936 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 62917 ? |
|---|---|
| Unique (%) | 4.4% |
Sample
| 1st row | Cibull |
|---|---|
| 2nd row | Cibull |
| 3rd row | Khalil |
| 4th row | Weigand |
| 5th row | Semonche |
Common Values
| Value | Count | Frequency (%) |
| Patel | 8615 | 0.6% |
| Smith | 7432 | 0.5% |
| Lee | 5285 | 0.4% |
| Johnson | 5247 | 0.4% |
| Walgreen Co | 5082 | 0.4% |
| Miller | 4341 | 0.3% |
| Brown | 3869 | 0.3% |
| Shah | 3820 | 0.3% |
| Williams | 3758 | 0.3% |
| Jones | 3523 | 0.2% |
| Other values (180849) | 1368291 |
Length
| Value | Count | Frequency (%) |
| llc | 18825 | 1.2% |
| inc | 17233 | 1.1% |
| patel | 8629 | 0.5% |
| smith | 7527 | 0.5% |
| of | 7435 | 0.5% |
| center | 6518 | 0.4% |
| co | 6464 | 0.4% |
| cvs | 6408 | 0.4% |
| walgreen | 5618 | 0.3% |
| johnson | 5333 | 0.3% |
| Other values (168303) | 1520522 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 49837 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 61069 |
| Missing (%) | 4.3% |
| Memory size | 10.8 MiB |
| Michael | 32465 |
|---|---|
| David | 29756 |
| John | 28498 |
| Robert | 23059 |
| James | 20998 |
| Other values (49832) |
Length
| Max length | 20 |
|---|---|
| Median length | 6 |
| Mean length | 5.934750853 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 16460 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | Thomas |
|---|---|
| 2nd row | Thomas |
| 3rd row | Rashid |
| 4th row | Frederick |
| 5th row | Amanda |
Common Values
| Value | Count | Frequency (%) |
| Michael | 32465 | 2.3% |
| David | 29756 | 2.1% |
| John | 28498 | 2.0% |
| Robert | 23059 | 1.6% |
| James | 20998 | 1.5% |
| William | 16196 | 1.1% |
| Mark | 15693 | 1.1% |
| Richard | 13650 | 1.0% |
| Thomas | 13179 | 0.9% |
| Christopher | 13022 | 0.9% |
| Other values (49827) | 1151678 | |
| (Missing) | 61069 | 4.3% |
Length
| Value | Count | Frequency (%) |
| michael | 32578 | 2.4% |
| david | 29824 | 2.2% |
| john | 28716 | 2.1% |
| robert | 23085 | 1.7% |
| james | 21047 | 1.5% |
| william | 16237 | 1.2% |
| mark | 15750 | 1.2% |
| richard | 13666 | 1.0% |
| thomas | 13226 | 1.0% |
| christopher | 13057 | 1.0% |
| Other values (46627) | 1160765 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 438461 |
| Missing (%) | 30.9% |
| Memory size | 10.8 MiB |
| A | |
|---|---|
| M | |
| J | |
| L | |
| S | |
| Other values (26) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | L |
|---|---|
| 2nd row | L |
| 3rd row | J |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| A | 113222 | 8.0% |
| M | 104021 | 7.3% |
| J | 90634 | 6.4% |
| L | 73318 | 5.2% |
| S | 62189 | 4.4% |
| R | 61945 | 4.4% |
| D | 56073 | 4.0% |
| E | 52808 | 3.7% |
| C | 52680 | 3.7% |
| B | 37775 | 2.7% |
| Other values (21) | 276137 | |
| (Missing) | 438461 |
Length
| Value | Count | Frequency (%) |
| a | 113222 | |
| m | 104021 | 10.6% |
| j | 90634 | 9.2% |
| l | 73318 | 7.5% |
| s | 62189 | 6.3% |
| r | 61945 | 6.3% |
| d | 56073 | 5.7% |
| e | 52808 | 5.4% |
| c | 52680 | 5.4% |
| b | 37775 | 3.9% |
| Other values (17) | 276137 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 9299 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 110474 |
| Missing (%) | 7.8% |
| Memory size | 10.8 MiB |
| M.D. | |
|---|---|
| MD | |
| D.O. | |
| DO | 35988 |
| PA-C | 32275 |
| Other values (9294) |
Length
| Max length | 20 |
|---|---|
| Median length | 4 |
| Mean length | 3.434573487 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 4280 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | M.D. |
|---|---|
| 2nd row | M.D. |
| 3rd row | M.D. |
| 4th row | MD |
| 5th row | DO |
Common Values
| Value | Count | Frequency (%) |
| M.D. | 449381 | |
| MD | 442868 | |
| D.O. | 52425 | 3.7% |
| DO | 35988 | 2.5% |
| PA-C | 32275 | 2.3% |
| DPM | 17232 | 1.2% |
| CRNA | 15249 | 1.1% |
| NP | 14802 | 1.0% |
| O.D. | 14577 | 1.0% |
| PA | 13471 | 0.9% |
| Other values (9289) | 220521 | |
| (Missing) | 110474 | 7.8% |
Length
| Value | Count | Frequency (%) |
| m.d | 474813 | |
| md | 453968 | |
| d.o | 56024 | 4.1% |
| do | 36518 | 2.7% |
| pa-c | 33637 | 2.5% |
| pt | 17609 | 1.3% |
| dpm | 17597 | 1.3% |
| dpt | 16412 | 1.2% |
| crna | 15741 | 1.1% |
| np | 15228 | 1.1% |
| Other values (3539) | 233307 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 61069 |
| Missing (%) | 4.3% |
| Memory size | 10.8 MiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| M | 910650 | |
| F | 447544 | |
| (Missing) | 61069 | 4.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| m | 910650 | |
| f | 447544 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| I | |
|---|---|
| O | 61069 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | I |
|---|---|
| 2nd row | I |
| 3rd row | I |
| 4th row | I |
| 5th row | I |
Common Values
| Value | Count | Frequency (%) |
| I | 1358194 | |
| O | 61069 | 4.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| i | 1358194 | |
| o | 61069 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 243256 |
|---|---|
| Distinct (%) | 17.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 200 1st St Sw | 4081 |
|---|---|
| 9500 Euclid Ave | 2440 |
| 4500 San Pablo Rd S | 1509 |
| 75 Francis St | 1408 |
| 200 Hawkins Dr | 1385 |
| Other values (243251) |
Length
| Max length | 55 |
|---|---|
| Median length | 17 |
| Mean length | 17.92835225 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 94418 ? |
|---|---|
| Unique (%) | 6.7% |
Sample
| 1st row | 2650 Ridge Ave |
|---|---|
| 2nd row | 2650 Ridge Ave |
| 3rd row | 4126 N Holland Sylvania Rd |
| 4th row | 1565 Saxon Blvd |
| 5th row | 1021 Park Ave |
Common Values
| Value | Count | Frequency (%) |
| 200 1st St Sw | 4081 | 0.3% |
| 9500 Euclid Ave | 2440 | 0.2% |
| 4500 San Pablo Rd S | 1509 | 0.1% |
| 75 Francis St | 1408 | 0.1% |
| 200 Hawkins Dr | 1385 | 0.1% |
| 5323 Harry Hines Blvd | 1359 | 0.1% |
| 12605 E 16th Ave | 1357 | 0.1% |
| 13400 E Shea Blvd | 1335 | 0.1% |
| 1 Medical Center Dr | 1314 | 0.1% |
| 1515 Holcombe Blvd | 1313 | 0.1% |
| Other values (243246) | 1401762 |
Length
| Value | Count | Frequency (%) |
| st | 326601 | 5.9% |
| ave | 257019 | 4.7% |
| rd | 229133 | 4.2% |
| dr | 170876 | 3.1% |
| ste | 167024 | 3.0% |
| n | 120869 | 2.2% |
| blvd | 118828 | 2.2% |
| w | 113201 | 2.1% |
| e | 107111 | 1.9% |
| s | 102917 | 1.9% |
| Other values (47201) | 3790751 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 41274 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 935854 |
| Missing (%) | 65.9% |
| Memory size | 10.8 MiB |
| Suite 200 | 18639 |
|---|---|
| Suite 100 | 17586 |
| Suite 101 | 9444 |
| Suite 300 | 8839 |
| Suite A | 7813 |
| Other values (41269) |
Length
| Max length | 55 |
|---|---|
| Median length | 9 |
| Mean length | 11.48792224 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 16117 ? |
|---|---|
| Unique (%) | 3.3% |
Sample
| 1st row | Evanston Hospital |
|---|---|
| 2nd row | Evanston Hospital |
| 3rd row | Suite 220 |
| 4th row | Suite 102 |
| 5th row | Suite 203 |
Common Values
| Value | Count | Frequency (%) |
| Suite 200 | 18639 | 1.3% |
| Suite 100 | 17586 | 1.2% |
| Suite 101 | 9444 | 0.7% |
| Suite 300 | 8839 | 0.6% |
| Suite A | 7813 | 0.6% |
| Suite 201 | 7629 | 0.5% |
| Suite B | 4964 | 0.3% |
| Suite 102 | 4914 | 0.3% |
| Ste 100 | 4514 | 0.3% |
| Suite 1 | 4444 | 0.3% |
| Other values (41264) | 394623 | |
| (Missing) | 935854 |
Length
| Value | Count | Frequency (%) |
| suite | 272728 | |
| ste | 68253 | 6.1% |
| 100 | 25514 | 2.3% |
| 200 | 25508 | 2.3% |
| of | 15974 | 1.4% |
| 300 | 13954 | 1.3% |
| 101 | 13741 | 1.2% |
| floor | 12895 | 1.2% |
| a | 12602 | 1.1% |
| department | 12287 | 1.1% |
| Other values (19369) | 641035 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10579 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| New York | 15341 |
|---|---|
| Houston | 12432 |
| Chicago | 10829 |
| Philadelphia | 9909 |
| Boston | 9177 |
| Other values (10574) |
Length
| Max length | 28 |
|---|---|
| Median length | 9 |
| Mean length | 8.93935303 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1689 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Evanston |
|---|---|
| 2nd row | Evanston |
| 3rd row | Toledo |
| 4th row | Deltona |
| 5th row | Quakertown |
Common Values
| Value | Count | Frequency (%) |
| New York | 15341 | 1.1% |
| Houston | 12432 | 0.9% |
| Chicago | 10829 | 0.8% |
| Philadelphia | 9909 | 0.7% |
| Boston | 9177 | 0.6% |
| Baltimore | 8898 | 0.6% |
| Dallas | 8715 | 0.6% |
| Springfield | 8501 | 0.6% |
| Columbus | 8388 | 0.6% |
| Los Angeles | 8037 | 0.6% |
| Other values (10569) | 1319036 |
Length
| Value | Count | Frequency (%) |
| city | 34531 | 1.9% |
| new | 29178 | 1.6% |
| san | 22958 | 1.3% |
| beach | 17876 | 1.0% |
| york | 17235 | 0.9% |
| fort | 15986 | 0.9% |
| saint | 13649 | 0.8% |
| park | 13567 | 0.7% |
| houston | 12568 | 0.7% |
| west | 12416 | 0.7% |
| Other values (8304) | 1626737 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 61 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| CA | |
|---|---|
| FL | |
| TX | |
| NY | 90202 |
| PA | 64824 |
| Other values (56) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IL |
|---|---|
| 2nd row | IL |
| 3rd row | OH |
| 4th row | FL |
| 5th row | PA |
Common Values
| Value | Count | Frequency (%) |
| CA | 110538 | 7.8% |
| FL | 102444 | 7.2% |
| TX | 96614 | 6.8% |
| NY | 90202 | 6.4% |
| PA | 64824 | 4.6% |
| IL | 57438 | 4.0% |
| OH | 52053 | 3.7% |
| NC | 51560 | 3.6% |
| MI | 47291 | 3.3% |
| NJ | 44655 | 3.1% |
| Other values (51) | 701644 |
Length
| Value | Count | Frequency (%) |
| ca | 110538 | 7.8% |
| fl | 102444 | 7.2% |
| tx | 96614 | 6.8% |
| ny | 90202 | 6.4% |
| pa | 64824 | 4.6% |
| il | 57438 | 4.0% |
| oh | 52053 | 3.7% |
| nc | 51560 | 3.6% |
| mi | 47291 | 3.3% |
| nj | 44655 | 3.1% |
| Other values (51) | 701644 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 853 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.36898711 |
| Minimum | 1 |
|---|---|
| Maximum | 78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 13 |
| median | 28 |
| Q3 | 42 |
| 95-th percentile | 51 |
| Maximum | 78 |
| Range | 77 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 15.65965276 |
|---|---|
| Coefficient of variation (CV) | 0.5519990087 |
| Kurtosis | -1.133610218 |
| Mean | 28.36898711 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.0001138981059 |
| Sum | 40238855 |
| Variance | 245.2247246 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 110465 | 7.8% |
| 12 | 102515 | 7.2% |
| 48 | 96600 | 6.8% |
| 36 | 90185 | 6.4% |
| 42 | 64823 | 4.6% |
| 17 | 57433 | 4.0% |
| 39 | 52005 | 3.7% |
| 37 | 51558 | 3.6% |
| 26 | 47268 | 3.3% |
| 34 | 44652 | 3.1% |
| Other values (46) | 700906 |
| Value | Count | Frequency (%) |
| 1 | 24523 | 1.7% |
| 2 | 2699 | 0.2% |
| 4 | 29812 | 2.1% |
| 5 | 15542 | 1.1% |
| 6 | 110465 | |
| 8 | 20485 | 1.4% |
| 9 | 18111 | 1.3% |
| 10 | 5366 | 0.4% |
| 11 | 3787 | 0.3% |
| 12 | 102515 |
| Value | Count | Frequency (%) |
| 78 | 218 | < 0.1% |
| 72 | 3575 | 0.3% |
| 69 | 24 | < 0.1% |
| 66 | 233 | < 0.1% |
| 60 | 1 | < 0.1% |
| 56 | 2562 | 0.2% |
| 55 | 25798 | |
| 54 | 8755 | 0.6% |
| 53 | 29439 | |
| 51 | 39681 |
| Distinct | 19042 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 77030 | 4678 |
|---|---|
| 55905 | 4119 |
| 72205 | 3279 |
| 63110 | 2840 |
| 44195 | 2830 |
| Other values (19037) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.926417443 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 2412 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 60201 |
|---|---|
| 2nd row | 60201 |
| 3rd row | 43623 |
| 4th row | 32725 |
| 5th row | 18951 |
Common Values
| Value | Count | Frequency (%) |
| 77030 | 4678 | 0.3% |
| 55905 | 4119 | 0.3% |
| 72205 | 3279 | 0.2% |
| 63110 | 2840 | 0.2% |
| 44195 | 2830 | 0.2% |
| 78229 | 2683 | 0.2% |
| 76104 | 2514 | 0.2% |
| 19104 | 2451 | 0.2% |
| 60611 | 2410 | 0.2% |
| 19107 | 2390 | 0.2% |
| Other values (19032) | 1389069 |
Length
| Value | Count | Frequency (%) |
| 77030 | 4678 | 0.3% |
| 55905 | 4119 | 0.3% |
| 72205 | 3279 | 0.2% |
| 63110 | 2840 | 0.2% |
| 44195 | 2830 | 0.2% |
| 78229 | 2683 | 0.2% |
| 76104 | 2514 | 0.2% |
| 19104 | 2451 | 0.2% |
| 60611 | 2410 | 0.2% |
| 19107 | 2390 | 0.2% |
| Other values (19035) | 1389076 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 853 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.603277684 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.648754583 |
|---|---|
| Coefficient of variation (CV) | 2.275809499 |
| Kurtosis | 596.5544717 |
| Mean | 1.603277684 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.65286645 |
| Sum | 2274105.1 |
| Variance | 13.31341 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1204683 | |
| 4 | 96432 | 6.8% |
| 2 | 33643 | 2.4% |
| 7 | 30459 | 2.1% |
| 1.1 | 20985 | 1.5% |
| 10 | 10406 | 0.7% |
| 5 | 6091 | 0.4% |
| 4.1 | 4926 | 0.3% |
| 7.1 | 2002 | 0.1% |
| 3 | 1749 | 0.1% |
| Other values (12) | 7034 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 1204683 | |
| 1.1 | 20985 | 1.5% |
| 2 | 33643 | 2.4% |
| 2.1 | 591 | < 0.1% |
| 3 | 1749 | 0.1% |
| 4 | 96432 | 6.8% |
| 4.1 | 4926 | 0.3% |
| 5 | 6091 | 0.4% |
| 5.1 | 157 | < 0.1% |
| 6 | 504 | < 0.1% |
| Value | Count | Frequency (%) |
| 99 | 1674 | 0.1% |
| 10.3 | 125 | < 0.1% |
| 10.2 | 564 | < 0.1% |
| 10.1 | 396 | < 0.1% |
| 10 | 10406 | |
| 9 | 633 | < 0.1% |
| 8.2 | 15 | < 0.1% |
| 8.1 | 7 | < 0.1% |
| 8 | 1476 | 0.1% |
| 7.2 | 892 | 0.1% |
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 853 |
| Missing (%) | 0.1% |
| Memory size | 10.8 MiB |
| Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | |
|---|---|
| Micropolitan area core: primary flow within an urban cluster of 10,000 to 49,999 | 96432 |
| Metropolitan area high commuting: primary flow 30% or more to a urbanized area of 50,000 and greater | 33643 |
| Small town core: primary flow within an urban cluster of 2,500 to 9,999 | 30459 |
| Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater | 21576 |
| Other values (10) | 31617 |
Length
| Max length | 100 |
|---|---|
| Median length | 83 |
| Mean length | 82.74279651 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
|---|---|
| 2nd row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
| 3rd row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
| 4th row | Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater |
| 5th row | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater |
Common Values
| Value | Count | Frequency (%) |
| Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | 1204683 | |
| Micropolitan area core: primary flow within an urban cluster of 10,000 to 49,999 | 96432 | 6.8% |
| Metropolitan area high commuting: primary flow 30% or more to a urbanized area of 50,000 and greater | 33643 | 2.4% |
| Small town core: primary flow within an urban cluster of 2,500 to 9,999 | 30459 | 2.1% |
| Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater | 21576 | 1.5% |
| Rural areas: primary flow to a tract outside a urbanized area of 50,000 and greater or UC | 10406 | 0.7% |
| Secondary flow 30% to <50% to a urbanized area of 50,000 and greater | 7488 | 0.5% |
| Micropolitan high commuting: primary flow 30% or more to a urban cluster of 10,000 to 49,999 | 6091 | 0.4% |
| Metropolitan area low commuting: primary flow 10% to <30% to a urbanized area of 50,000 and greater | 1749 | 0.1% |
| Unknown | 1674 | 0.1% |
| Other values (5) | 4209 | 0.3% |
Length
| Value | Count | Frequency (%) |
| area | 2616052 | |
| flow | 1416736 | 7.6% |
| of | 1416736 | 7.6% |
| primary | 1386076 | 7.4% |
| core | 1331574 | 7.1% |
| within | 1331574 | 7.1% |
| an | 1331574 | 7.1% |
| and | 1279545 | 6.9% |
| greater | 1279545 | 6.9% |
| urbanized | 1279545 | 6.9% |
| Other values (29) | 3983274 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| US | |
|---|---|
| JP | 21 |
| CA | 11 |
| JO | 8 |
| DE | 7 |
| Other values (14) | 50 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| US | 1419166 | |
| JP | 21 | < 0.1% |
| CA | 11 | < 0.1% |
| JO | 8 | < 0.1% |
| DE | 7 | < 0.1% |
| LB | 6 | < 0.1% |
| TH | 6 | < 0.1% |
| GB | 6 | < 0.1% |
| TR | 5 | < 0.1% |
| IT | 5 | < 0.1% |
| Other values (9) | 22 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| us | 1419166 | |
| jp | 21 | < 0.1% |
| ca | 11 | < 0.1% |
| jo | 8 | < 0.1% |
| de | 7 | < 0.1% |
| lb | 6 | < 0.1% |
| th | 6 | < 0.1% |
| gb | 6 | < 0.1% |
| it | 5 | < 0.1% |
| tr | 5 | < 0.1% |
| Other values (9) | 22 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| Diagnostic Radiology | |
|---|---|
| Internal Medicine | |
| Family Practice | |
| Nurse Practitioner | |
| Physician Assistant | 62410 |
| Other values (94) |
Length
| Max length | 55 |
|---|---|
| Median length | 17 |
| Mean length | 17.88965611 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pathology |
|---|---|
| 2nd row | Pathology |
| 3rd row | Anesthesiology |
| 4th row | Family Practice |
| 5th row | Internal Medicine |
Common Values
| Value | Count | Frequency (%) |
| Diagnostic Radiology | 175963 | 12.4% |
| Internal Medicine | 142736 | 10.1% |
| Family Practice | 131193 | 9.2% |
| Nurse Practitioner | 98738 | 7.0% |
| Physician Assistant | 62410 | 4.4% |
| Cardiology | 59880 | 4.2% |
| Physical Therapist in Private Practice | 44709 | 3.2% |
| Orthopedic Surgery | 40875 | 2.9% |
| Anesthesiology | 34588 | 2.4% |
| Ophthalmology | 33476 | 2.4% |
| Other values (89) | 594695 |
Length
| Value | Count | Frequency (%) |
| medicine | 196255 | 7.1% |
| practice | 185058 | 6.7% |
| radiology | 183415 | 6.6% |
| diagnostic | 180522 | 6.5% |
| internal | 142736 | 5.1% |
| family | 131193 | 4.7% |
| nurse | 118571 | 4.3% |
| practitioner | 98738 | 3.5% |
| surgery | 84413 | 3.0% |
| cardiology | 74034 | 2.7% |
| Other values (150) | 1387052 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| True | |
|---|---|
| False | 451 |
| Value | Count | Frequency (%) |
| True | 1418812 | |
| False | 451 | < 0.1% |
| Distinct | 4604 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 99213 | 65930 |
|---|---|
| 99214 | 64193 |
| 99204 | 26519 |
| 99203 | 25383 |
| 99232 | 25211 |
| Other values (4599) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 779 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 88341 |
|---|---|
| 2nd row | 88348 |
| 3rd row | 99213 |
| 4th row | 99204 |
| 5th row | 90662 |
Common Values
| Value | Count | Frequency (%) |
| 99213 | 65930 | 4.6% |
| 99214 | 64193 | 4.5% |
| 99204 | 26519 | 1.9% |
| 99203 | 25383 | 1.8% |
| 99232 | 25211 | 1.8% |
| G0008 | 20180 | 1.4% |
| 99223 | 19237 | 1.4% |
| 99233 | 17891 | 1.3% |
| 99215 | 17817 | 1.3% |
| 99212 | 16686 | 1.2% |
| Other values (4594) | 1120216 |
Length
| Value | Count | Frequency (%) |
| 99213 | 65930 | 4.6% |
| 99214 | 64193 | 4.5% |
| 99204 | 26519 | 1.9% |
| 99203 | 25383 | 1.8% |
| 99232 | 25211 | 1.8% |
| g0008 | 20180 | 1.4% |
| 99223 | 19237 | 1.4% |
| 99233 | 17891 | 1.3% |
| 99215 | 17817 | 1.3% |
| 99212 | 16686 | 1.2% |
| Other values (4594) | 1120216 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4239 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| Established patient office or other outpatient visit, typically 15 minutes | 65930 |
|---|---|
| Established patient office or other outpatient, visit typically 25 minutes | 64193 |
| New patient office or other outpatient visit, typically 45 minutes | 26519 |
| New patient office or other outpatient visit, typically 30 minutes | 25383 |
| Subsequent hospital inpatient care, typically 25 minutes per day | 25211 |
| Other values (4234) |
Length
| Max length | 256 |
|---|---|
| Median length | 61 |
| Mean length | 61.42576323 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 688 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Special stained specimen slides to examine tissue |
|---|---|
| 2nd row | Electron microscopy for diagnosis |
| 3rd row | Established patient office or other outpatient visit, typically 15 minutes |
| 4th row | New patient office or other outpatient visit, typically 45 minutes |
| 5th row | Vaccine for influenza for injection into muscle |
Common Values
| Value | Count | Frequency (%) |
| Established patient office or other outpatient visit, typically 15 minutes | 65930 | 4.6% |
| Established patient office or other outpatient, visit typically 25 minutes | 64193 | 4.5% |
| New patient office or other outpatient visit, typically 45 minutes | 26519 | 1.9% |
| New patient office or other outpatient visit, typically 30 minutes | 25383 | 1.8% |
| Subsequent hospital inpatient care, typically 25 minutes per day | 25211 | 1.8% |
| Administration of influenza virus vaccine | 20180 | 1.4% |
| Vaccine for influenza for injection into muscle | 19985 | 1.4% |
| Initial hospital inpatient care, typically 70 minutes per day | 19237 | 1.4% |
| Subsequent hospital inpatient care, typically 35 minutes per day | 17891 | 1.3% |
| Established patient office or other outpatient, visit typically 40 minutes | 17817 | 1.3% |
| Other values (4229) | 1116917 |
Length
| Value | Count | Frequency (%) |
| of | 766603 | 6.0% |
| or | 502526 | 3.9% |
| minutes | 461110 | 3.6% |
| typically | 376220 | 2.9% |
| visit | 322261 | 2.5% |
| patient | 304113 | 2.4% |
| and | 251909 | 2.0% |
| other | 244826 | 1.9% |
| outpatient | 236534 | 1.8% |
| office | 236255 | 1.8% |
| Other values (3503) | 9103205 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
HCPCS_Drug_Ind
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| False | |
|---|---|
| True | 87372 |
| Value | Count | Frequency (%) |
| False | 1331891 | |
| True | 87372 | 6.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| O | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | O |
| 5th row | O |
Common Values
| Value | Count | Frequency (%) |
| O | 875453 | |
| F | 543810 |
Length
Pie chart
| Value | Count | Frequency (%) |
| o | 875453 | |
| f | 543810 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3691 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 11 | 69540 |
|---|---|
| 12 | 61948 |
| 13 | 55465 |
| 14 | 50197 |
| 15 | 45533 |
| Other values (3686) |
Length
| Max length | 7 |
|---|---|
| Median length | 2 |
| Mean length | 2.193651212 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1707 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 93 |
|---|---|
| 2nd row | 22 |
| 3rd row | 24 |
| 4th row | 25 |
| 5th row | 93 |
Common Values
| Value | Count | Frequency (%) |
| 11 | 69540 | 4.9% |
| 12 | 61948 | 4.4% |
| 13 | 55465 | 3.9% |
| 14 | 50197 | 3.5% |
| 15 | 45533 | 3.2% |
| 16 | 41787 | 2.9% |
| 17 | 38336 | 2.7% |
| 18 | 35546 | 2.5% |
| 19 | 32649 | 2.3% |
| 20 | 31025 | 2.2% |
| Other values (3681) | 957237 |
Length
| Value | Count | Frequency (%) |
| 11 | 69540 | 4.9% |
| 12 | 61948 | 4.4% |
| 13 | 55465 | 3.9% |
| 14 | 50197 | 3.5% |
| 15 | 45533 | 3.2% |
| 16 | 41787 | 2.9% |
| 17 | 38336 | 2.7% |
| 18 | 35546 | 2.5% |
| 19 | 32649 | 2.3% |
| 20 | 31025 | 2.2% |
| Other values (3681) | 957237 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 10080 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 12 | 44049 |
|---|---|
| 13 | 42054 |
| 11 | 40839 |
| 14 | 39678 |
| 15 | 37129 |
| Other values (10075) |
Length
| Max length | 11 |
|---|---|
| Median length | 2 |
| Mean length | 2.34128206 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 5287 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 322 |
|---|---|
| 2nd row | 22 |
| 3rd row | 28 |
| 4th row | 25 |
| 5th row | 99 |
Common Values
| Value | Count | Frequency (%) |
| 12 | 44049 | 3.1% |
| 13 | 42054 | 3.0% |
| 11 | 40839 | 2.9% |
| 14 | 39678 | 2.8% |
| 15 | 37129 | 2.6% |
| 16 | 34801 | 2.5% |
| 17 | 32394 | 2.3% |
| 18 | 30377 | 2.1% |
| 19 | 28456 | 2.0% |
| 20 | 27091 | 1.9% |
| Other values (10070) | 1062395 |
Length
| Value | Count | Frequency (%) |
| 12 | 44049 | 3.1% |
| 13 | 42054 | 3.0% |
| 11 | 40839 | 2.9% |
| 14 | 39678 | 2.8% |
| 15 | 37129 | 2.6% |
| 16 | 34801 | 2.5% |
| 17 | 32394 | 2.3% |
| 18 | 30377 | 2.1% |
| 19 | 28456 | 2.0% |
| 20 | 27091 | 1.9% |
| Other values (10070) | 1062395 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5073 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| 12 | 47081 |
|---|---|
| 11 | 44782 |
| 13 | 44557 |
| 14 | 41677 |
| 15 | 38851 |
| Other values (5068) |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.291354034 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 2005 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 98 |
|---|---|
| 2nd row | 22 |
| 3rd row | 28 |
| 4th row | 25 |
| 5th row | 99 |
Common Values
| Value | Count | Frequency (%) |
| 12 | 47081 | 3.3% |
| 11 | 44782 | 3.2% |
| 13 | 44557 | 3.1% |
| 14 | 41677 | 2.9% |
| 15 | 38851 | 2.7% |
| 16 | 36380 | 2.6% |
| 17 | 33796 | 2.4% |
| 18 | 31659 | 2.2% |
| 19 | 29477 | 2.1% |
| 20 | 28144 | 2.0% |
| Other values (5063) | 1042859 |
Length
| Value | Count | Frequency (%) |
| 12 | 47081 | 3.3% |
| 11 | 44782 | 3.2% |
| 13 | 44557 | 3.1% |
| 14 | 41677 | 2.9% |
| 15 | 38851 | 2.7% |
| 16 | 36380 | 2.6% |
| 17 | 33796 | 2.4% |
| 18 | 31659 | 2.2% |
| 19 | 29477 | 2.1% |
| 20 | 28144 | 2.0% |
| Other values (5063) | 1042859 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 128266 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $150.00 | 13848 |
|---|---|
| $50.00 | 13005 |
| $100.00 | 11912 |
| $30.00 | 11504 |
| $40.00 | 10444 |
| Other values (128261) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.764222699 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 59441 ? |
|---|---|
| Unique (%) | 4.2% |
Sample
| 1st row | $92.00 |
|---|---|
| 2nd row | $350.00 |
| 3rd row | $96.00 |
| 4th row | $499.00 |
| 5th row | $82.73 |
Common Values
| Value | Count | Frequency (%) |
| $150.00 | 13848 | 1.0% |
| $50.00 | 13005 | 0.9% |
| $100.00 | 11912 | 0.8% |
| $30.00 | 11504 | 0.8% |
| $40.00 | 10444 | 0.7% |
| $200.00 | 10412 | 0.7% |
| $25.00 | 10097 | 0.7% |
| $35.00 | 9661 | 0.7% |
| $60.00 | 9526 | 0.7% |
| $75.00 | 9014 | 0.6% |
| Other values (128256) | 1309840 |
Length
| Value | Count | Frequency (%) |
| 150.00 | 13848 | 1.0% |
| 50.00 | 13005 | 0.9% |
| 100.00 | 11912 | 0.8% |
| 30.00 | 11504 | 0.8% |
| 40.00 | 10444 | 0.7% |
| 200.00 | 10412 | 0.7% |
| 25.00 | 10097 | 0.7% |
| 35.00 | 9661 | 0.7% |
| 60.00 | 9526 | 0.7% |
| 75.00 | 9014 | 0.6% |
| Other values (128256) | 1309840 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 68010 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $2.94 | 9681 |
|---|---|
| $2.44 | 5874 |
| $18.65 | 5096 |
| $3.41 | 4769 |
| $10.57 | 4536 |
| Other values (68005) |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.224355176 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 28828 ? |
|---|---|
| Unique (%) | 2.0% |
Sample
| 1st row | $30.63 |
|---|---|
| 2nd row | $81.68 |
| 3rd row | $48.82 |
| 4th row | $165.77 |
| 5th row | $54.65 |
Common Values
| Value | Count | Frequency (%) |
| $2.94 | 9681 | 0.7% |
| $2.44 | 5874 | 0.4% |
| $18.65 | 5096 | 0.4% |
| $3.41 | 4769 | 0.3% |
| $10.57 | 4536 | 0.3% |
| $54.89 | 4179 | 0.3% |
| $4.28 | 3363 | 0.2% |
| $8.46 | 3342 | 0.2% |
| $0.11 | 2881 | 0.2% |
| $11.51 | 2542 | 0.2% |
| Other values (68000) | 1373000 |
Length
| Value | Count | Frequency (%) |
| 2.94 | 9681 | 0.7% |
| 2.44 | 5874 | 0.4% |
| 18.65 | 5096 | 0.4% |
| 3.41 | 4769 | 0.3% |
| 10.57 | 4536 | 0.3% |
| 54.89 | 4179 | 0.3% |
| 4.28 | 3363 | 0.2% |
| 8.46 | 3342 | 0.2% |
| 0.11 | 2881 | 0.2% |
| 11.51 | 2542 | 0.2% |
| Other values (68000) | 1373000 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 59738 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $2.94 | 9688 |
|---|---|
| $2.44 | 5811 |
| $18.65 | 5100 |
| $3.41 | 4792 |
| $10.57 | 4570 |
| Other values (59733) |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.069952504 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 25313 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | $24.49 |
|---|---|
| 2nd row | $65.30 |
| 3rd row | $30.35 |
| 4th row | $98.33 |
| 5th row | $54.65 |
Common Values
| Value | Count | Frequency (%) |
| $2.94 | 9688 | 0.7% |
| $2.44 | 5811 | 0.4% |
| $18.65 | 5100 | 0.4% |
| $3.41 | 4792 | 0.3% |
| $10.57 | 4570 | 0.3% |
| $54.89 | 4261 | 0.3% |
| $0.09 | 3399 | 0.2% |
| $4.28 | 3391 | 0.2% |
| $8.46 | 3240 | 0.2% |
| $11.51 | 2509 | 0.2% |
| Other values (59728) | 1372502 |
Length
| Value | Count | Frequency (%) |
| 2.94 | 9688 | 0.7% |
| 2.44 | 5811 | 0.4% |
| 18.65 | 5100 | 0.4% |
| 3.41 | 4792 | 0.3% |
| 10.57 | 4570 | 0.3% |
| 54.89 | 4261 | 0.3% |
| 0.09 | 3399 | 0.2% |
| 4.28 | 3391 | 0.2% |
| 8.46 | 3240 | 0.2% |
| 11.51 | 2509 | 0.2% |
| Other values (59728) | 1372502 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 53642 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.8 MiB |
| $16.60 | 24613 |
|---|---|
| $2.94 | 14065 |
| $115.84 | 9099 |
| $2.44 | 7300 |
| $10.57 | 6615 |
| Other values (53637) |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.07057043 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 21509 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | $23.45 |
|---|---|
| 2nd row | $62.44 |
| 3rd row | $32.58 |
| 4th row | $97.31 |
| 5th row | $54.65 |
Common Values
| Value | Count | Frequency (%) |
| $16.60 | 24613 | 1.7% |
| $2.94 | 14065 | 1.0% |
| $115.84 | 9099 | 0.6% |
| $2.44 | 7300 | 0.5% |
| $10.57 | 6615 | 0.5% |
| $82.79 | 6386 | 0.4% |
| $3.41 | 5831 | 0.4% |
| $57.92 | 5620 | 0.4% |
| $58.20 | 5278 | 0.4% |
| $8.46 | 5201 | 0.4% |
| Other values (53632) | 1329255 |
Length
| Value | Count | Frequency (%) |
| 16.60 | 24613 | 1.7% |
| 2.94 | 14065 | 1.0% |
| 115.84 | 9099 | 0.6% |
| 2.44 | 7300 | 0.5% |
| 10.57 | 6615 | 0.5% |
| 82.79 | 6386 | 0.4% |
| 3.41 | 5831 | 0.4% |
| 57.92 | 5620 | 0.4% |
| 58.20 | 5278 | 0.4% |
| 8.46 | 5201 | 0.4% |
| Other values (53632) | 1329255 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Rndrng_NPI | Rndrng_Prvdr_Last_Org_Name | Rndrng_Prvdr_First_Name | Rndrng_Prvdr_MI | Rndrng_Prvdr_Crdntls | Rndrng_Prvdr_Gndr | Rndrng_Prvdr_Ent_Cd | Rndrng_Prvdr_St1 | Rndrng_Prvdr_St2 | Rndrng_Prvdr_City | Rndrng_Prvdr_State_Abrvtn | Rndrng_Prvdr_State_FIPS | Rndrng_Prvdr_Zip5 | Rndrng_Prvdr_RUCA | Rndrng_Prvdr_RUCA_Desc | Rndrng_Prvdr_Cntry | Rndrng_Prvdr_Type | Rndrng_Prvdr_Mdcr_Prtcptg_Ind | HCPCS_Cd | HCPCS_Desc | HCPCS_Drug_Ind | Place_Of_Srvc | Tot_Benes | Tot_Srvcs | Tot_Bene_Day_Srvcs | Avg_Sbmtd_Chrg | Avg_Mdcr_Alowd_Amt | Avg_Mdcr_Pymt_Amt | Avg_Mdcr_Stdzd_Amt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1003000134 | Cibull | Thomas | L | M.D. | M | I | 2650 Ridge Ave | Evanston Hospital | Evanston | IL | 17.0 | 60201 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Pathology | Y | 88341 | Special stained specimen slides to examine tissue | N | F | 93 | 322 | 98 | $92.00 | $30.63 | $24.49 | $23.45 |
| 1 | 1003000134 | Cibull | Thomas | L | M.D. | M | I | 2650 Ridge Ave | Evanston Hospital | Evanston | IL | 17.0 | 60201 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Pathology | Y | 88348 | Electron microscopy for diagnosis | N | F | 22 | 22 | 22 | $350.00 | $81.68 | $65.30 | $62.44 |
| 2 | 1003000142 | Khalil | Rashid | NaN | M.D. | M | I | 4126 N Holland Sylvania Rd | Suite 220 | Toledo | OH | 39.0 | 43623 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Anesthesiology | Y | 99213 | Established patient office or other outpatient visit, typically 15 minutes | N | F | 24 | 28 | 28 | $96.00 | $48.82 | $30.35 | $32.58 |
| 3 | 1003000522 | Weigand | Frederick | J | MD | M | I | 1565 Saxon Blvd | Suite 102 | Deltona | FL | 12.0 | 32725 | 1.1 | Secondary flow 30% to <50% to a larger urbanized area of 50,000 and greater | US | Family Practice | Y | 99204 | New patient office or other outpatient visit, typically 45 minutes | N | O | 25 | 25 | 25 | $499.00 | $165.77 | $98.33 | $97.31 |
| 4 | 1003000530 | Semonche | Amanda | M | DO | F | I | 1021 Park Ave | Suite 203 | Quakertown | PA | 42.0 | 18951 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 90662 | Vaccine for influenza for injection into muscle | Y | O | 93 | 99 | 99 | $82.73 | $54.65 | $54.65 | $54.65 |
| 5 | 1003000530 | Semonche | Amanda | M | DO | F | I | 1021 Park Ave | Suite 203 | Quakertown | PA | 42.0 | 18951 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 99496 | Transitional care management services, highly complexity, requiring face-to-face visits within 7 days of discharge | N | O | 11 | 13 | 13 | $404.23 | $245.10 | $183.94 | $173.07 |
| 6 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 51702 | Insertion of indwelling bladder catheter | N | O | 16 | 22 | 22 | $212.00 | $58.49 | $44.64 | $47.68 |
| 7 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 51741 | Electronic assessment of bladder emptying | N | O | 86 | 96 | 96 | $34.00 | $13.42 | $10.16 | $10.67 |
| 8 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 51798 | Ultrasound measurement of bladder capacity after voiding | N | O | 199 | 233 | 233 | $32.00 | $11.56 | $9.05 | $9.98 |
| 9 | 1003000597 | Kim | Dae | Y | M.D., PH.D | M | I | 1145 S Utica Ave | Suite 202 | Tulsa | OK | 40.0 | 74104 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Urology | Y | 52204 | Biopsy of the bladder using an endoscope | N | F | 22 | 22 | 22 | $745.00 | $134.65 | $106.14 | $107.04 |
Last rows
| Rndrng_NPI | Rndrng_Prvdr_Last_Org_Name | Rndrng_Prvdr_First_Name | Rndrng_Prvdr_MI | Rndrng_Prvdr_Crdntls | Rndrng_Prvdr_Gndr | Rndrng_Prvdr_Ent_Cd | Rndrng_Prvdr_St1 | Rndrng_Prvdr_St2 | Rndrng_Prvdr_City | Rndrng_Prvdr_State_Abrvtn | Rndrng_Prvdr_State_FIPS | Rndrng_Prvdr_Zip5 | Rndrng_Prvdr_RUCA | Rndrng_Prvdr_RUCA_Desc | Rndrng_Prvdr_Cntry | Rndrng_Prvdr_Type | Rndrng_Prvdr_Mdcr_Prtcptg_Ind | HCPCS_Cd | HCPCS_Desc | HCPCS_Drug_Ind | Place_Of_Srvc | Tot_Benes | Tot_Srvcs | Tot_Bene_Day_Srvcs | Avg_Sbmtd_Chrg | Avg_Mdcr_Alowd_Amt | Avg_Mdcr_Pymt_Amt | Avg_Mdcr_Stdzd_Amt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1419253 | 1992999122 | Johnson | Charles | R | D.O. | M | I | 1601 Clint Moore Rd | 155 | Boca Raton | FL | 12.0 | 33487 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | G0403 | Electrocardiogram, routine ecg with 12 leads; performed as a screening for the initial preventive physical examination with interpretation and report | N | O | 25 | 25 | 25 | $25.00 | $17.85 | $9.64 | $9.22 |
| 1419254 | 1992999122 | Johnson | Charles | R | D.O. | M | I | 1601 Clint Moore Rd | 155 | Boca Raton | FL | 12.0 | 33487 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | G0439 | Annual wellness visit, includes a personalized prevention plan of service (pps), subsequent visit | N | O | 467 | 467 | 467 | $150.11 | $119.93 | $119.93 | $115.87 |
| 1419255 | 1992999270 | Bennett | Stephanie | R | PA-C | F | I | 5999 Dundee Rd | Suite 750 | Winter Haven | FL | 12.0 | 33884 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Physician Assistant | Y | 99214 | Established patient office or other outpatient, visit typically 25 minutes | N | O | 38 | 44 | 44 | $273.00 | $90.62 | $53.80 | $55.62 |
| 1419256 | 1992999437 | Rivera Mendez | Jose | L | M.D. | M | I | 1600 S Andrews Ave | NaN | Fort Lauderdale | FL | 12.0 | 33316 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Emergency Medicine | Y | 99284 | Emergency department visit, problem of high severity | N | F | 23 | 23 | 23 | $1,236.00 | $131.28 | $100.00 | $89.73 |
| 1419257 | 1992999551 | Molai | Indira | NaN | M.D. | F | I | 625 E Grand Ave | NaN | Escondido | CA | 6.0 | 92025 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 81003 | Automated urinalysis test | N | O | 47 | 56 | 56 | $6.66 | $2.44 | $2.44 | $2.44 |
| 1419258 | 1992999551 | Molai | Indira | NaN | M.D. | F | I | 625 E Grand Ave | NaN | Escondido | CA | 6.0 | 92025 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Internal Medicine | Y | 90653 | Vaccine for influenza for injection into muscle | Y | O | 50 | 50 | 50 | $120.00 | $58.34 | $58.34 | $58.34 |
| 1419259 | 1992999775 | Spine Surgery Center Of Eugene, Llc | NaN | NaN | NaN | NaN | O | 1410 Oak St | Suite 300 | Eugene | OR | 41.0 | 97401 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Ambulatory Surgical Center | Y | 63047 | Partial removal of middle spine bone with release of spinal cord and/or nerves | N | F | 23 | 23 | 23 | $15,000.00 | $2,955.25 | $2,352.15 | $2,149.15 |
| 1419260 | 1992999825 | Deschenes | Geoffrey | R | M.D. | M | I | 1100 9th Ave | Ms:m4-Pfs | Seattle | WA | 53.0 | 98101 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Otolaryngology | Y | 30140 | Removal of nasal air passage | N | F | 11 | 11 | 11 | $1,819.50 | $159.64 | $117.02 | $108.50 |
| 1419261 | 1992999825 | Deschenes | Geoffrey | R | M.D. | M | I | 1100 9th Ave | Ms:m4-Pfs | Seattle | WA | 53.0 | 98101 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Otolaryngology | Y | 99203 | New patient office or other outpatient visit, typically 30 minutes | N | F | 29 | 29 | 29 | $150.00 | $81.53 | $60.69 | $56.54 |
| 1419262 | 1992999825 | Deschenes | Geoffrey | R | M.D. | M | I | 1100 9th Ave | Ms:m4-Pfs | Seattle | WA | 53.0 | 98101 | 1.0 | Metropolitan area core: primary flow within an urbanized area of 50,000 and greater | US | Otolaryngology | Y | 99214 | Established patient office or other outpatient, visit typically 25 minutes | N | F | 92 | 115 | 115 | $150.19 | $83.80 | $63.96 | $59.98 |